| 0.0009 |
SELECT `p`.`id`
FROM `kdo_pozemky` `p`
WHERE `p`.`oznaceni_projekt` = 'RD-8'
AND `p`.`stav_prodeje` IN(77, 78, 79)
LIMIT 1
|
| 0.0006 |
SELECT `p`.`oznaceni_projekt` `oznaceni`, `p`.`typovy_dum`, `p`.`orientace`, `p`.`plocha1`, IF(`p`.`stav_prodeje` IN (77), p.cena1, 0) cena1, `p`.`text1`, `p`.`text2`, `s`.`id` `sid`, `s`.`nazev` `stav`
FROM `kdo_pozemky` `p`
LEFT JOIN `kdo_hodnoty` `s` ON `s`.`id` = `p`.`stav_prodeje`
WHERE `p`.`id` = '8'
AND `p`.`stav_prodeje` IN(77, 78, 79)
LIMIT 1
|
| 0.0009 |
SELECT `o`.`nazev`, `o`.`soubor`
FROM `kdo_obrazky` `o`
WHERE `o`.`tabulka` = 'pozemky'
AND `o`.`radek` = '8'
AND `o`.`kategorie` = 24
AND `o`.`stav` = 9
ORDER BY `o`.`kategorie`, `o`.`vaha` DESC, `o`.`id`
|
| 0.0006 |
SELECT `p`.`nazev`, `p`.`soubor`
FROM `kdo_prilohy` `p`
WHERE `p`.`tabulka` = 'pozemky'
AND `p`.`radek` = '8'
AND `p`.`kategorie` = 87
AND `p`.`stav` = 9
ORDER BY `p`.`vaha` DESC, `p`.`id`
LIMIT 1
|
| 0.0009 |
SELECT `d`.`nazev`, `d`.`popis_dispozice` `dispozice`, `d`.`plocha1`, `d`.`popis`
FROM `kdo_domy` `d`
WHERE `d`.`id` = '4'
AND `d`.`stav` = 9
LIMIT 1
|
| 0.0011 |
SELECT `m`.`cislo`, `m`.`nazev`, `m`.`plocha`, `m`.`patro`
FROM `kdo_mistnosti` `m`
WHERE `m`.`dum` = '4'
AND `m`.`stav` = 9
ORDER BY `m`.`vaha` DESC, `m`.`cislo`
|
| 0.0007 |
SELECT `o`.`nazev`, `o`.`soubor`
FROM `kdo_obrazky` `o`
WHERE `o`.`tabulka` = 'domy'
AND `o`.`radek` = '4'
AND `o`.`kategorie` = 23
AND `o`.`stav` = 9
ORDER BY `o`.`kategorie`, `o`.`vaha` DESC, `o`.`id`
|
| 0.0007 |
SELECT `p`.`nazev`, `p`.`soubor`
FROM `kdo_prilohy` `p`
WHERE `p`.`tabulka` = 'domy'
AND `p`.`radek` = '4'
AND `p`.`kategorie` = 29
AND `p`.`stav` = 9
ORDER BY `p`.`vaha` DESC, `p`.`id`
LIMIT 1
|
| 0.0006 |
SELECT `p`.`soubor`
FROM `kdo_prilohy` `p`
WHERE `p`.`tabulka` = 'dokumenty'
AND `p`.`radek` = 2
LIMIT 1
|
